<?php
		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/header.php");
	ExcuteSQL("DROP TABLE IF EXISTS `phpyun_partclass`;");
CreateTable("CREATE TABLE `phpyun_partclass` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `keyid` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `variable` varchar(50) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8");
ExcuteSQL("insert into `phpyun_partclass` values('1','0','工作类型','part_type','0');");
ExcuteSQL("insert into `phpyun_partclass` values('2','0','薪水类型','part_salary_type','0');");
ExcuteSQL("insert into `phpyun_partclass` values('3','0','结算周期','part_billing_cycle','0');");
ExcuteSQL("insert into `phpyun_partclass` values('4','0','性别要求','part_sex','0');");
ExcuteSQL("insert into `phpyun_partclass` values('5','1','传单派发',NULL,'1');");
ExcuteSQL("insert into `phpyun_partclass` values('6','1','促销导购',NULL,'2');");
ExcuteSQL("insert into `phpyun_partclass` values('7','1','话务客服',NULL,'3');");
ExcuteSQL("insert into `phpyun_partclass` values('8','1','礼仪模特',NULL,'4');");
ExcuteSQL("insert into `phpyun_partclass` values('9','1','老师家教',NULL,'5');");
ExcuteSQL("insert into `phpyun_partclass` values('10','1','服务员',NULL,'6');");
ExcuteSQL("insert into `phpyun_partclass` values('11','1','问卷调查',NULL,'7');");
ExcuteSQL("insert into `phpyun_partclass` values('12','1','审核录入',NULL,'8');");
ExcuteSQL("insert into `phpyun_partclass` values('13','1','地推拉访',NULL,'9');");
ExcuteSQL("insert into `phpyun_partclass` values('14','1','其他',NULL,'10');");
ExcuteSQL("insert into `phpyun_partclass` values('15','2','元/天',NULL,'1');");
ExcuteSQL("insert into `phpyun_partclass` values('16','2','元/周',NULL,'2');");
ExcuteSQL("insert into `phpyun_partclass` values('17','2','元/月',NULL,'3');");
ExcuteSQL("insert into `phpyun_partclass` values('18','2','元/小时',NULL,'4');");
ExcuteSQL("insert into `phpyun_partclass` values('19','2','元/次',NULL,'5');");
ExcuteSQL("insert into `phpyun_partclass` values('20','3','日结',NULL,'1');");
ExcuteSQL("insert into `phpyun_partclass` values('21','3','周结',NULL,'2');");
ExcuteSQL("insert into `phpyun_partclass` values('22','3','月结',NULL,'3');");
ExcuteSQL("insert into `phpyun_partclass` values('23','3','完工结',NULL,'4');");
ExcuteSQL("insert into `phpyun_partclass` values('24','4','不限',NULL,'1');");
ExcuteSQL("insert into `phpyun_partclass` values('25','4','男',NULL,'2');");
ExcuteSQL("insert into `phpyun_partclass` values('26','4','女',NULL,'3');");

		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/footer.php");
	?>